=($I$5-C17)*$F$7-$F$6 =($I$5-$B17)*$F$7-$F$6 =(Q17) =($F$8)+(($I$5-D17)*$F$7)-$F$6 =(S17) "Trailing Stop Loss: Should initially be the same as the ""Initial Stop" "=(IF(B17>$F$10,1,0))" "=(IF(C17<$F$11,1,0))" "=(IF(OR(O17=1,P17=1),""Out"",""In""))" "=(IF(H17<$F$5,""Yes"",""No""))"
=($I$5-C18)*$F$7-$F$6 =($I$5-$B18)*$F$7-$F$6 =(Q18) =($F$8)+(($I$5-D18)*$F$7)-$F$6 =(S18) " Loss"" and then adjust as the price moves in" "=(IF(B18>$F$10,1,0))" "=(IF(C18<$F$11,1,0))" "=(IF(OR(O18=1,P18=1),""Out"",""In""))" "=(IF(H18<$F$5,""Yes"",""No""))"
=($I$5-C19)*$F$7-$F$6 =($I$5-$B19)*$F$7-$F$6 =(Q19) =($F$8)+(($I$5-D19)*$F$7)-$F$6 =(S19) price moves in your favor and according to your "=(IF(B19>$F$10,1,0))" "=(IF(C19<$F$11,1,0))" "=(IF(OR(O19=1,P19=1),""Out"",""In""))" "=(IF(H19<$F$5,""Yes"",""No""))"
=($I$5-C21)*$F$7-$F$6 =($I$5-$B21)*$F$7-$F$6 =(Q21) =($F$8)+(($I$5-D21)*$F$7)-$F$6 =(S21) Target Stop: Use this if you want to liquidate at a specific profit. "=(IF(B21>$F$10,1,0))" "=(IF(C21<$F$11,1,0))" "=(IF(OR(O21=1,P21=1),""Out"",""In""))" "=(IF(H21<$F$5,""Yes"",""No""))"
=($I$5-C22)*$F$7-$F$6 =($I$5-$B22)*$F$7-$F$6 =(Q22) =($F$8)+(($I$5-D22)*$F$7)-$F$6 =(S22) "Date Sold: Enter nothing, this is referenced to the date you open" "=(IF(B22>$F$10,1,0))" "=(IF(C22<$F$11,1,0))" "=(IF(OR(O22=1,P22=1),""Out"",""In""))" "=(IF(H22<$F$5,""Yes"",""No""))"
=($I$5-C24)*$F$7-$F$6 =($I$5-$B24)*$F$7-$F$6 =(Q24) =($F$8)+(($I$5-D24)*$F$7)-$F$6 =(S24) Price Sold: Enter the price at which the order was actually executed. "=(IF(B24>$F$10,1,0))" "=(IF(C24<$F$11,1,0))" "=(IF(OR(O24=1,P24=1),""Out"",""In""))" "=(IF(H24<$F$5,""Yes"",""No""))"
=($I$5-C25)*$F$7-$F$6 =($I$5-$B25)*$F$7-$F$6 =(Q25) =($F$8)+(($I$5-D25)*$F$7)-$F$6 =(S25) Date Liquidated: Enter the date you liquidated the contract. "=(IF(B25>$F$10,1,0))" "=(IF(C25<$F$11,1,0))" "=(IF(OR(O25=1,P25=1),""Out"",""In""))" "=(IF(H25<$F$5,""Yes"",""No""))"
=($I$5-C26)*$F$7-$F$6 =($I$5-$B26)*$F$7-$F$6 =(Q26) =($F$8)+(($I$5-D26)*$F$7)-$F$6 =(S26) Price Liquidated: Enter the price at which the contract was actually "=(IF(B26>$F$10,1,0))" "=(IF(C26<$F$11,1,0))" "=(IF(OR(O26=1,P26=1),""Out"",""In""))" "=(IF(H26<$F$5,""Yes"",""No""))"
=($I$5-C28)*$F$7-$F$6 =($I$5-$B28)*$F$7-$F$6 =(Q28) =($F$8)+(($I$5-D28)*$F$7)-$F$6 =(S28) P/L: Enter nothing. The profit/loss is calculated and includes the "=(IF(B28>$F$10,1,0))" "=(IF(C28<$F$11,1,0))" "=(IF(OR(O28=1,P28=1),""Out"",""In""))" "=(IF(H28<$F$5,""Yes"",""No""))"
=($I$5-C30)*$F$7-$F$6 =($I$5-$B30)*$F$7-$F$6 =(Q30) =($F$8)+(($I$5-D30)*$F$7)-$F$6 =(S30) "Price Data: Paste or enter the Date, High, Low and Close for each" "=(IF(B30>$F$10,1,0))" "=(IF(C30<$F$11,1,0))" "=(IF(OR(O30=1,P30=1),""Out"",""In""))" "=(IF(H30<$F$5,""Yes"",""No""))"
=($I$5-C31)*$F$7-$F$6 =($I$5-$B31)*$F$7-$F$6 =(Q31) =($F$8)+(($I$5-D31)*$F$7)-$F$6 =(S31) trading session that the position is open. "=(IF(B31>$F$10,1,0))" "=(IF(C31<$F$11,1,0))" "=(IF(OR(O31=1,P31=1),""Out"",""In""))" "=(IF(H31<$F$5,""Yes"",""No""))"
=($I$5-C32)*$F$7-$F$6 =($I$5-$B32)*$F$7-$F$6 =(Q32) =($F$8)+(($I$5-D32)*$F$7)-$F$6 =(S32) Profit High: Enter nothing. Calculated by subtracting the session's "=(IF(B32>$F$10,1,0))" "=(IF(C32<$F$11,1,0))" "=(IF(OR(O32=1,P32=1),""Out"",""In""))" "=(IF(H32<$F$5,""Yes"",""No""))"
=($I$5-C33)*$F$7-$F$6 =($I$5-$B33)*$F$7-$F$6 =(Q33) =($F$8)+(($I$5-D33)*$F$7)-$F$6 =(S33) " low price from the price at which you sold the contract," "=(IF(B33>$F$10,1,0))" "=(IF(C33<$F$11,1,0))" "=(IF(OR(O33=1,P33=1),""Out"",""In""))" "=(IF(H33<$F$5,""Yes"",""No""))"
=($I$5-C34)*$F$7-$F$6 =($I$5-$B34)*$F$7-$F$6 =(Q34) =($F$8)+(($I$5-D34)*$F$7)-$F$6 =(S34) multipying by the Point Value and then subtracting the "=(IF(B34>$F$10,1,0))" "=(IF(C34<$F$11,1,0))" "=(IF(OR(O34=1,P34=1),""Out"",""In""))" "=(IF(H34<$F$5,""Yes"",""No""))"
=($I$5-C36)*$F$7-$F$6 =($I$5-$B36)*$F$7-$F$6 =(Q36) =($F$8)+(($I$5-D36)*$F$7)-$F$6 =(S36) Profit Low: Enter nothing. Calculated by subtracting the session's "=(IF(B36>$F$10,1,0))" "=(IF(C36<$F$11,1,0))" "=(IF(OR(O36=1,P36=1),""Out"",""In""))" "=(IF(H36<$F$5,""Yes"",""No""))"
=($I$5-C37)*$F$7-$F$6 =($I$5-$B37)*$F$7-$F$6 =(Q37) =($F$8)+(($I$5-D37)*$F$7)-$F$6 =(S37) " high price from the price at which you sold the contract," "=(IF(B37>$F$10,1,0))" "=(IF(C37<$F$11,1,0))" "=(IF(OR(O37=1,P37=1),""Out"",""In""))" "=(IF(H37<$F$5,""Yes"",""No""))"
=($I$5-C38)*$F$7-$F$6 =($I$5-$B38)*$F$7-$F$6 =(Q38) =($F$8)+(($I$5-D38)*$F$7)-$F$6 =(S38) multipying by the Point Value and then subtracting the "=(IF(B38>$F$10,1,0))" "=(IF(C38<$F$11,1,0))" "=(IF(OR(O38=1,P38=1),""Out"",""In""))" "=(IF(H38<$F$5,""Yes"",""No""))"
=($I$5-C40)*$F$7-$F$6 =($I$5-$B40)*$F$7-$F$6 =(Q40) =($F$8)+(($I$5-D40)*$F$7)-$F$6 =(S40) "Stopped Out: Enter nothing. ""Out"" will be printed if the price moves" "=(IF(B40>$F$10,1,0))" "=(IF(C40<$F$11,1,0))" "=(IF(OR(O40=1,P40=1),""Out"",""In""))" "=(IF(H40<$F$5,""Yes"",""No""))"
=($I$5-C41)*$F$7-$F$6 =($I$5-$B41)*$F$7-$F$6 =(Q41) =($F$8)+(($I$5-D41)*$F$7)-$F$6 =(S41) above your Trailing Stop Loss or below your Target "=(IF(B41>$F$10,1,0))" "=(IF(C41<$F$11,1,0))" "=(IF(OR(O41=1,P41=1),""Out"",""In""))" "=(IF(H41<$F$5,""Yes"",""No""))"
=($I$5-C43)*$F$7-$F$6 =($I$5-$B43)*$F$7-$F$6 =(Q43) =($F$8)+(($I$5-D43)*$F$7)-$F$6 =(S43) Trading Account (Close): Enter nothing. Calculated by subtracting "=(IF(B43>$F$10,1,0))" "=(IF(C43<$F$11,1,0))" "=(IF(OR(O43=1,P43=1),""Out"",""In""))" "=(IF(H43<$F$5,""Yes"",""No""))"
=($I$5-C44)*$F$7-$F$6 =($I$5-$B44)*$F$7-$F$6 =(Q44) =($F$8)+(($I$5-D44)*$F$7)-$F$6 =(S44) the product of the session's close multi- "=(IF(B44>$F$10,1,0))" "=(IF(C44<$F$11,1,0))" "=(IF(OR(O44=1,P44=1),""Out"",""In""))" "=(IF(H44<$F$5,""Yes"",""No""))"
=($I$5-C45)*$F$7-$F$6 =($I$5-$B45)*$F$7-$F$6 =(Q45) =($F$8)+(($I$5-D45)*$F$7)-$F$6 =(S45) plied by the point value from the Starting "=(IF(B45>$F$10,1,0))" "=(IF(C45<$F$11,1,0))" "=(IF(OR(O45=1,P45=1),""Out"",""In""))" "=(IF(H45<$F$5,""Yes"",""No""))"
=($I$5-C46)*$F$7-$F$6 =($I$5-$B46)*$F$7-$F$6 =(Q46) =($F$8)+(($I$5-D46)*$F$7)-$F$6 =(S46) Acct. Bal and then subtracting the "=(IF(B46>$F$10,1,0))" "=(IF(C46<$F$11,1,0))" "=(IF(OR(O46=1,P46=1),""Out"",""In""))" "=(IF(H46<$F$5,""Yes"",""No""))"
=($I$5-C48)*$F$7-$F$6 =($I$5-$B48)*$F$7-$F$6 =(Q48) =($F$8)+(($I$5-D48)*$F$7)-$F$6 =(S48) "Margin Call: Enter nothing. A ""Yes"" will appear if the Trading" "=(IF(B48>$F$10,1,0))" "=(IF(C48<$F$11,1,0))" "=(IF(OR(O48=1,P48=1),""Out"",""In""))" "=(IF(H48<$F$5,""Yes"",""No""))"
=($I$5-C50)*$F$7-$F$6 =($I$5-$B50)*$F$7-$F$6 =(Q50) =($F$8)+(($I$5-D50)*$F$7)-$F$6 =(S50) Comments: Enter all of your observations including why you "=(IF(B50>$F$10,1,0))" "=(IF(C50<$F$11,1,0))" "=(IF(OR(O50=1,P50=1),""Out"",""In""))" "=(IF(H50<$F$5,""Yes"",""No""))"
=($I$5-C51)*$F$7-$F$6 =($I$5-$B51)*$F$7-$F$6 =(Q51) =($F$8)+(($I$5-D51)*$F$7)-$F$6 =(S51) change either the Trailing or Target stops. "=(IF(B51>$F$10,1,0))" "=(IF(C51<$F$11,1,0))" "=(IF(OR(O51=1,P51=1),""Out"",""In""))" "=(IF(H51<$F$5,""Yes"",""No""))"
=($I$5-C52)*$F$7-$F$6 =($I$5-$B52)*$F$7-$F$6 =(Q52) =($F$8)+(($I$5-D52)*$F$7)-$F$6 =(S52) "Final Note: Remember to ""Select"" and ""Print Selection"" because of " "=(IF(B52>$F$10,1,0))" "=(IF(C52<$F$11,1,0))" "=(IF(OR(O52=1,P52=1),""Out"",""In""))" "=(IF(H52<$F$5,""Yes"",""No""))"
=($I$5-C53)*$F$7-$F$6 =($I$5-$B53)*$F$7-$F$6 =(Q53) =($F$8)+(($I$5-D53)*$F$7)-$F$6 =(S53) " the large table. Table set up for 8.5""x11"" landscape." "=(IF(B53>$F$10,1,0))" "=(IF(C53<$F$11,1,0))" "=(IF(OR(O53=1,P53=1),""Out"",""In""))" "=(IF(H53<$F$5,""Yes"",""No""))"